package com.tqw.favorites.dao;

import com.tqw.favorites.pojo.Favorites;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Van
 */
@Mapper
public interface FavoritesMapper {
    @Select("SELECT i.id,i.title,i.sell_point,i.price,i.font_image FROM favorites f LEFT JOIN item i ON f.item_id = i.id WHERE f.user_id = #{id};")
    List<Favorites> selectFavoritesById(Integer id);
}
